package site.kexing.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import site.kexing.pojo.Product_Order;
import site.kexing.pojo.Product_Plan;

import java.util.List;

@Mapper
@Repository
public interface Product_PlanMapper {
    //查询所有计划
    List<Product_Plan> selectAllProduct_Plan();
    Product_Plan selectProduct_PlanByID(Integer id);
    int updateProduct_Plan(Product_Plan product_plan);
    int deleteProduct_Plan(Integer id);
    int insertProduct_Plan(Product_Plan product_plan);
    List<Product_Plan> selectProduct_PlanByOrderID(Integer orderID);
    //更改计划状态为已完成
    int updateProduct_plan_status(Integer order_id);
    List<Integer> selectAllProduct_PlanID();
    //根据订单ID查询所有计划ID
    List<Integer> selectAllPlanIDSByOrderID(Integer order_id);


}
